Views [dbo].[vSoaGeneralReference]
SQLServer > iMIS1521GA > Views > dbo.vSoaGeneralReference
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:38:39 PM Friday, January 07, 2011
Last Modified1:49:26 PM Thursday, September 22, 2011
Columns
Name
GeneralReferenceId
Table
Name
Description
SQL Script

CREATE VIEW [dbo].[vSoaGeneralReference]
AS
  SELECT CAST(gt.[TABLE_NAME] + ':' + gt.[CODE] AS NVARCHAR(1000)) AS [GeneralReferenceId],
       gt.[TABLE_NAME] AS [Table],
       gt.[CODE] AS [Name],
       CAST(gt.[DESCRIPTION] AS NVARCHAR(1000)) AS [Description]
  FROM [dbo].[Gen_Tables] gt
  WHERE gt.[SUBSTITUTE] NOT IN (select [CODE] from [dbo].[Gen_Tables] where [TABLE_NAME] = gt.[TABLE_NAME])


GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved